home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Aminet 32
/
Aminet 32 (1999)(Schatztruhe)[!][Aug 1999].iso
/
Aminet
/
biz
/
swood
/
CanMortgage.readme
< prev
next >
Wrap
Text File
|
1999-07-01
|
2KB
|
53 lines
Short: Final Calc Canadian Mortgage Evaluation Worksheet
Author: bsavage@accesscable.net (Brian Savage)
Uploader: bsavage@accesscable.net (Brian Savage)
Type: biz/swood
Requires: Final Calc
This Final Calc worksheet is comprised of 3 sheets:
Mortgage Tables - monthly payment lookup table with
interest rate (6-8.75%) vs principle
($54,000-$160,000) with adjustable amortization
period.
Mortgage Calculator - simple payment calculator - enter amount to
finance, amortization period & interest
Mortgage Evaluation - shows where all the money is going (i.e.
principle & interest for each payment &
affect of extra payments on amortization)
Use alt-s to toggle between sheets (or Project/Sheet/View from the menu).
The formulae are customized for Canadian mortgages although should be
adaptable for other countries. Solutions are accurate to within 1 cent
when compared to mortgage tables obtained from my bank.
All sheets should be self explanatory although some notes are
included for interest rate calculation.
Use or modify these sheets at will - just send me an email if you have
suggestions, find bugs or if you have any questions.
Also check out my homepage for other Amiga software I have written. Its
all free!
Brian Savage
Dartmouth, Nova Scotia
Canada
email: mailto:bsavage@accesscable.net
homepage: http://homepage.accesscable.net/~bsavage
============================= Archive contents =============================
Original Packed Ratio Date Time Name
-------- ------- ----- --------- -------- -------------
2171 733 66.2% 14-Jun-99 21:16:14 Canadian_Interest.readme
107236 24532 77.1% 10-Jun-99 21:46:22 Canadian_Mortgage.sheet
1571 736 53.1% 14-Jun-99 21:19:12 CanMortgage.readme
-------- ------- ----- --------- --------
110978 26001 76.5% 15-Jun-99 18:44:12 3 files